package com.jy.adscm.hospital.mapper;

import com.jy.adscm.hospital.bean.JyHospitalBase;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.jy.adscm.hospital.support.HospitalSelectSupport;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 医院基础信息表 Mapper 接口
 * </p>
 *
 * @author yyy
 * @since 2019-01-16
 */
public interface JyHospitalBaseMapper extends BaseMapper<JyHospitalBase> {


    List<JyHospitalBase> queryAllHospitalBaseList();
    List<JyHospitalBase> queryAllHospitalBaseList1();

    @Select("SELECT id,hospital_name hospitalName FROM jy_hospital_base ORDER BY input_time DESC")
    List<HospitalSelectSupport> queryAllHospitalList();

    List<JyHospitalBase> queryHospitalListByLikeName(@Param("name") String name);

    /**
     * 查询所有医院的名字、地址、ID
     * @return
     */
    List<JyHospitalBase> queryAllHospitalNameList();

}
